Microsoft Power BI Desktop Course
Skill Success
Summary
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
This course is about how to gather data, transform data and model data before you create visualizations to explain the data and share valuable insights with your organization. In this course, you will learn how to install PowerBI, how to get data from multiple sources, both internal and external. Connecting to different types of files of data, Folders or data and online data. Setting up data queries and transforming the data into a format that can be used and much more. By taking this course now, you will learn BI for data analytics.
Benefits of taking this course include:
- Unlimited and lifetime access to the course
- Learn the course at your own pace
- Course can be accessed on any platform
- 24/7 Customer support
Course media
Description
Power BI brings the world of data analytics to the ordinary business, by connecting to data from multiple sources and transforming or modelling that data, you can view and share insights to your business like never before. Being a self-service system, means you don’t need the help of and IT department to transform or model the data.
LEARN TO GATHER DATA, TRANSFORM DATA AND MODEL DATA BEFORE YOU CREATE VISUALIZATIONS TO EXPLAIN THE DATA AND SHARE VALUABLE INSIGHTS WITH YOUR ORGANISATION.
- This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.
- This course is for you if you are looking to learn Power BI Self Service functions.
- This course is not for you if you are new to Excel.
Microsoft Power BI Desktop Course will cover the following topics:
Topic 1 - Power BI Desktop Introduction
- Introduction
- Download PowerBI Desktop
- Lets Take A Tour Around The Desktop Application
- How To Take This Course
Topic 2 - Get And Query Data
- Activity And Workbooks
- Introduction To The Query Editor Section
- Connect And Transform Data From An Excel Workbook
- Connect And Transform Folders Of Data
- Unpivot Data
- Setting Up A Date (Calendar) Table Using Query
- Connect To A .Txt File
- Connect To Data On The Web
- Activity
Topic 3 - DAX
- DAX Introduction
- Relationships
- Calculated Columns
- Measures
- The X-Functions
- Related And Related Table Expressions
- The Filter Expressions
- Calculate Function
- Other DAX Functions
- More On DAX
- More On Calculated Columns And Measures
- Time Intelligence Functions
Topic 4 - Visualizations
- Introduction To Visulaizations
- The Canvas And Your First Visualization
- Line Charts And Hierarchy
- Adding Slicers
- Gauges, KPI’s And Cards
- Scatter Charts
- Conclusion
Who is this course for?
This course is designed for anyone who is interested in learning BI for data analytics.
Requirements
No prior knowledge is required to take this course.
Questions and answers
Good Afternoon, I'm looking to learn Power BI and came across your course. Is your course video driven? Many Thanks Mark
Answer:Hi Mark, the course lesson is a combination of video format and slide presentations. :)
This was helpful.Is any special software required?
Answer:Hi Robert, you may take the course without any software on hand. But if you have the program, it will greatly help you in applying what you've learned from the course. :)
This was helpful.
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Add to basket or enquire
Course provided by
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
